Printing an Inventory Dates Inquiry
Once you have entered all of the required information needed to generate an Inventory Dates Inquiry, command options will appear allowing you to print or choose from a set of other print options.
The following information fields are displayed:
- Grp – The item group
- Item Name – The name of the item and the type of inventory transactions associated with the item. Inventory transaction types are:
- Sale – Sales order
- Credit – Credit order
- Inventory adjustments – The cost adjustment type will be displayed in this field
- Adjustment – Weight only adjustment, no value adjustment
- Transfers in
- Transfers out
- Hold Purchase Order – Hold Purchase Orders are purchases entered through Purchase Orders and received through Receiving Purchase Orders, but not yet completed, and therefore, still on hold.
- Hold Purchasing – Hold Purchasing indicates the product was received and completed on inventory hold.
- Purchase – Purchase order
- WO (work order) Raw Material
- WO Dry Good
- WO Finished Good
- Vendor/Cust – The vendor from whom this item was purchased or the customer to whom this item was sold. A blank field or '//////' indicates that the vendor identity has been lost, due to the combination of multiple lots from multiple vendors.
- Ref # – The reference number of the inventory transaction
- Cost/Price – The per unit cost at which this item was purchased, or the per unit price at which this item was sold. Inventory adjustments display as the total net change of the valuation of the item.
- Un – The invoicing unit of measure. This is the unit of measure in which the cost/price is stated.
- Quantity – The total quantity of the inventory transaction. Sale, Transfer Out, WO Raw Material, and WO Dry Good display as negative quantities, as all of these transactions subtract from inventory. Credit added back to inventory, Purchase, Transfer In, and WO Finished Goods, display as positive quantities, as all of these transactions add into inventory. Inventory adjustments and weight adjustments may be positive or negative.
Note: The current on hand amount (On Hand Now) will always be listed on the first line of the display for each item.
- Un - This column displays the stocking unit of measure. This is the unit of measure in which the Quantity is stated.
- Date – The date on which this transaction occurred.
For more information on the Inventory Dates Inquiry see Inventory Dates Inquiry.
Security Required : Inventory - Inventory Inquiry